--- title: SAIF.Business.Claim.Legal SQL catalog summary: Index of all 205 SQL statements used by this library, grouped by operation type. status: draft owner: SAIF Documentation Generator last_reviewed: 2026-08-21 library: SAIF.Business.Claim.Legal reference_type: embedded --- # SAIF.Business.Claim.Legal SQL catalog This page indexes all 205 SQL statements and stored-procedure calls in this library, grouped by CRUD type. Given the scale of this library, closely-related statements are grouped onto shared detail pages by CRUD type; every SQL ID still has its own labeled subsection with full classification, parameters, tables, sample SQL and sources on the linked page. ## Sequence operations | SQL ID | Description | Sequence | Tables | Business object | | --- | --- | --- | --- | --- | | [SQL-001](sql-001-to-sql-014-sequences.md#sql-001-clsappealcriteriacreatesql) | Acquire next appeal sequence value | `APPEAL_SEQ_NUM` | [DUAL](../database-tables.md#dual) | `clsAppeal` | | [SQL-002](sql-001-to-sql-014-sequences.md#sql-002-clsattorneyconflictcriteriacreatesql) | Acquire next attorney conflict sequence value | `ATTORNEY_CONFLICT_SEQ_NUM` | [DUAL](../database-tables.md#dual) | `clsAttorneyConflict` | | [SQL-003](sql-001-to-sql-014-sequences.md#sql-003-clsattorneypolicyassignmentcriteriacreatesql) | Acquire next attorney policy assignment sequence value | `ATTY_POLICY_ASSGN_SEQ_NUM` | [DUAL](../database-tables.md#dual) | `clsAttorneyPolicyAssignment` | | [SQL-004](sql-001-to-sql-014-sequences.md#sql-004-clsattorneyschedulecriteriacreatesql) | Acquire next attorney schedule sequence value | `ATTORNEY_SCHEDULE_SEQ_NUM` | [DUAL](../database-tables.md#dual) | `clsAttorneySchedule` | | [SQL-005](sql-001-to-sql-014-sequences.md#sql-005-clsattorneyworkerassignmentcriteriacreatesql) | Acquire next attorney worker assignment sequence value | `ATTORNEY_WORKER_ASSGN_SEQ_NUM` | [DUAL](../database-tables.md#dual) | `clsAttorneyWorkerAssignment` | | [SQL-006](sql-001-to-sql-014-sequences.md#sql-006-clscreatefile-print-control) | Acquire next print control sequence value | `xprint_control_seq` | [DUAL](../database-tables.md#dual) | `clsCreateFile` | | [SQL-007](sql-001-to-sql-014-sequences.md#sql-007-clshearinglocationcriteriacreatesql) | Acquire next hearing location sequence value | `HEARING_LOCATION_SEQ_NUM` | [DUAL](../database-tables.md#dual) | `clsHearingLocation` | | [SQL-008](sql-001-to-sql-014-sequences.md#sql-008-clslegalcasecriteriacreatesql) | Acquire next legal case sequence value | `LEGAL_CASE_SEQ_NUM` | [DUAL](../database-tables.md#dual) | `clsLegalCase` | | [SQL-009](sql-001-to-sql-014-sequences.md#sql-009-clslegalpersoncriteriacreatesql) | Acquire next legal person sequence value | `LEGAL_PERSON_SEQ_NUM` | [DUAL](../database-tables.md#dual) | `clsLegalPerson` | | [SQL-010](sql-001-to-sql-014-sequences.md#sql-010-clslegalpersontypecriteriacreatesql) | Acquire next legal person type sequence value | `LEGAL_PERSON_SEQ_NUM` | [DUAL](../database-tables.md#dual) | `clsLegalPersonType` | | [SQL-011](sql-001-to-sql-014-sequences.md#sql-011-clslegalschedulecriteriacreatesql) | Acquire next schedule sequence value | `SCHEDULE_SEQ_NUM` | [DUAL](../database-tables.md#dual) | `clsLegalSchedule` | | [SQL-012](sql-001-to-sql-014-sequences.md#sql-012-clsotherfirmcriteriacreatesql) | Acquire next other firm sequence value | `OTHER_FIRM_SEQ_NUM` | [DUAL](../database-tables.md#dual) | `clsOtherFirm` | | [SQL-013](sql-001-to-sql-014-sequences.md#sql-013-clsoutcomestaffcriteriacreatesql) | Acquire next outcome staff sequence value | `OUTCOME_STAFF_SEQ_NUM` | [DUAL](../database-tables.md#dual) | `clsOutcomeStaff` | | [SQL-014](sql-001-to-sql-014-sequences.md#sql-014-clsoutoftownrotationassgncriteriacreatesql) | Acquire next out-of-town rotation sequence value | `OUT_OF_TOWN_ROTATION_SEQ_NUM` | [DUAL](../database-tables.md#dual) | `clsOutOFTownRotationAssgn` | 23 additional sequences (`Appeal_SEQ`, `Case_Cost_SEQ`, `case_note_seq`, and others) are obtained through the BOF helper `GetNextSeqNum("")` rather than explicit `CreateSQL` text and are not individually numbered — see [SQL-001 to SQL-014](sql-001-to-sql-014-sequences.md) for the full list. ## Create operations | SQL ID | Description | Type | Tables | Business object | | --- | --- | --- | --- | --- | | [SQL-015](sql-015-to-sql-039-inserts.md#sql-015-clsappeal) | Insert a new appeal | Stored Proc | `pk80001_legalnet.insertAppeal` | `clsAppeal` | | [SQL-016](sql-015-to-sql-039-inserts.md#sql-016-clsappealextension) | Insert a new appeal extension | Stored Proc | `pk80001_legalnet.insertAppealExtension` | `clsAppealExtension` | | [SQL-017](sql-015-to-sql-039-inserts.md#sql-017-clsattorneyconflictcriteriainsertsql) | Insert a new attorney conflict record | Inline | [ATTORNEY_CONFLICT](../database-tables.md#attorney_conflict) | `clsAttorneyConflict` | | [SQL-018](sql-015-to-sql-039-inserts.md#sql-018-clsattorneypolicyassignmentcriteriainsertsql) | Insert a new attorney policy assignment | Inline | [ATTORNEY_POLICY_ASSIGNMENT](../database-tables.md#attorney_policy_assignment) | `clsAttorneyPolicyAssignment` | | [SQL-019](sql-015-to-sql-039-inserts.md#sql-019-clsattorneyprofile) | Insert a new attorney profile | Stored Proc | `pk80001_legalnet.insertAttyProfile` | `clsAttorneyProfile` | | [SQL-020](sql-015-to-sql-039-inserts.md#sql-020-clsattorneyschedulecriteriainsertsql) | Insert a new attorney schedule entry | Inline | [ATTORNEY_SCHEDULE](../database-tables.md#attorney_schedule) | `clsAttorneySchedule` | | [SQL-021](sql-015-to-sql-039-inserts.md#sql-021-clsattorneyworkerassignmentcriteriainsertsql) | Insert a new attorney worker assignment | Inline | [ATTORNEY_WORKER_ASSIGNMENT](../database-tables.md#attorney_worker_assignment) | `clsAttorneyWorkerAssignment` | | [SQL-022](sql-015-to-sql-039-inserts.md#sql-022-clscasecostcriteriainsertsql) | Insert a new case cost record | Inline | [CASE_COST](../database-tables.md#case_cost) | `clsCaseCost` | | [SQL-023](sql-015-to-sql-039-inserts.md#sql-023-clscasenote) | Insert a new case note | Stored Proc | `pk80001_legalnet.case_note_insert` | `clsCaseNote` | | [SQL-024](sql-015-to-sql-039-inserts.md#sql-024-clscaseoutcome) | Insert a new case outcome | Stored Proc | `pk80001_legalnet.InsertCaseOutcome` | `clsCaseOutcome` | | [SQL-025](sql-015-to-sql-039-inserts.md#sql-025-clscasestatushistorycriteriainsertsql) | Insert a new case status history record | Inline | [CASE_STATUS_HISTORY](../database-tables.md#case_status_history) | `clsCaseStatusHistory` | | [SQL-026](sql-015-to-sql-039-inserts.md#sql-026-clshearinglocationcriteriainsertsql) | Insert a new hearing location | Inline | [HEARING_LOCATION](../database-tables.md#hearing_location) | `clsHearingLocation` | | [SQL-027](sql-015-to-sql-039-inserts.md#sql-027-clshearinglocationinfocriteriainsertsql) | Insert hearing location info | Inline | [HEARING_LOCATION](../database-tables.md#hearing_location) | `clsHearingLocationInfo` | | [SQL-028](sql-015-to-sql-039-inserts.md#sql-028-clslegalcase) | Insert a new legal case | Stored Proc | `pk80001_legalnet.InsertLegalCase` | `clsLegalCase` | | [SQL-029](sql-015-to-sql-039-inserts.md#sql-029-clslegalcaseevaluation) | Insert a new legal case evaluation | Stored Proc | `pk80001_legalnet.InsertLCE` | `clsLegalCaseEvaluation` | | [SQL-030](sql-015-to-sql-039-inserts.md#sql-030-clslegalfilelocation) | Insert a new legal file location | Stored Proc | `pk80001_legalnet.insertFileLocation` | `clsLegalFileLocation` | | [SQL-031](sql-015-to-sql-039-inserts.md#sql-031-clslegalpersoncriteriainsertsql) | Insert a new legal person | Inline | [LEGAL_PERSON](../database-tables.md#legal_person) | `clsLegalPerson` | | [SQL-032](sql-015-to-sql-039-inserts.md#sql-032-clslegalpersontypecriteriainsertsql) | Insert a new legal person type | Inline | [LEGAL_PERSON_TYPE](../database-tables.md#legal_person_type) | `clsLegalPersonType` | | [SQL-033](sql-015-to-sql-039-inserts.md#sql-033-clslegalschedule) | Insert a new legal schedule | Stored Proc | `pk80001_legalnet.insertSchedule` | `clsLegalSchedule` | | [SQL-034](sql-015-to-sql-039-inserts.md#sql-034-clsotherfirmcriteriainsertsql) | Insert a new other firm | Inline | [OTHER_FIRM](../database-tables.md#other_firm) | `clsOtherFirm` | | [SQL-035](sql-015-to-sql-039-inserts.md#sql-035-clsotherlegalpartycriteriainsertsql) | Insert a new other legal party | Inline | [LEGAL_CASE_EMPLOYER](../database-tables.md#legal_case_employer) | `clsOtherLegalParty` | | [SQL-036](sql-015-to-sql-039-inserts.md#sql-036-clsoutcomeissuecriteriainsertsql) | Insert a new outcome issue | Inline | [OUTCOME_ISSUE](../database-tables.md#outcome_issue) | `clsOutcomeIssue` | | [SQL-037](sql-015-to-sql-039-inserts.md#sql-037-clsoutcomestaffcriteriainsertsql) | Insert a new outcome staff entry | Inline | [OUTCOME_STAFF](../database-tables.md#outcome_staff) | `clsOutcomeStaff` | | [SQL-038](sql-015-to-sql-039-inserts.md#sql-038-clsoutoftownrotationassgncriteriainsertsql) | Insert a new out-of-town rotation assignment | Inline | [OUT_OF_TOWN_ROTATION_ASSGN](../database-tables.md#out_of_town_rotation_assgn) | `clsOutOFTownRotationAssgn` | | [SQL-039](sql-015-to-sql-039-inserts.md#sql-039-clsrequestissuecriteriainsertsql) | Insert a new request issue | Inline | [REQUEST_ISSUE](../database-tables.md#request_issue) | `clsRequestIssue` | ## Read operations Reads span two detail pages: business-object/collection reads ([SQL-040 to SQL-119](sql-040-to-sql-119-reads.md), 80 statements) and cached code-table reads ([SQL-120 to SQL-150](sql-120-to-sql-150-code-tables.md), 31 statements). Representative entries: | SQL ID | Description | Type | Tables | Business object | | --- | --- | --- | --- | --- | | [SQL-086](sql-040-to-sql-119-reads.md#sql-086-clslegalcasecriteriaretrievesql) | Retrieve a legal case by sequence number | Stored Proc | `pk80001_legalnet.getLegalCase` | `clsLegalCase` | | [SQL-101](sql-040-to-sql-119-reads.md#sql-101-clslegalschedulecriteriaretrievesql) | Retrieve a legal schedule | Stored Proc | `pk80001_legalnet.getSchedule` | `clsLegalSchedule` | | [SQL-072](sql-040-to-sql-119-reads.md#sql-072-clscasesearchcasesearch) | Execute a legal-case search | Stored Proc | `pk80001_legalnet.CaseSearch` | `clsCaseSearch` | | [SQL-052](sql-040-to-sql-119-reads.md#sql-052-clsattorneyconflictcollectiongetattorneyconflicts) | Retrieve attorney conflicts joined with adjuster/provider/policy/legal-person data | Inline | [ATTORNEY_CONFLICT](../database-tables.md#attorney_conflict), [ADP_EMPLOYEE](../database-tables.md#adp_employee), [PROVIDER_LOCATION](../database-tables.md#provider_location), [POLICY](../database-tables.md#policy), [LEGAL_PERSON](../database-tables.md#legal_person) | `clsAttorneyConflictCollection` | | [SQL-102](sql-040-to-sql-119-reads.md#sql-102-clsletterrequest-case-lookup) | Look up a case for letter generation | Inline | [LEGAL.VW_CASES](../database-tables.md#legalvw_cases) | `clsLetterRequest` | | [Code-table SQL group](sql-120-to-sql-150-code-tables.md) | Load cached code-table lookups (31 statements) | Inline (SQL-132 Stored Proc) | Various `code` tables, `ADP_EMPLOYEE`, `PROVIDER_LOCATION`, `LEGAL_PERSON` | `mdlCodeTables` cache classes | See the two linked pages for the complete list of all 111 Read operations. ## Update operations Documented in full on [SQL-151 to SQL-183](sql-151-to-sql-183-updates.md) (33 statements). Representative entries: | SQL ID | Description | Type | Tables | Business object | | --- | --- | --- | --- | --- | | [SQL-168](sql-151-to-sql-183-updates.md#sql-168-clslegalcase) | Update an existing legal case | Stored Proc | `pk80001_legalnet.UpdateLegalCase` | `clsLegalCase` | | [SQL-174](sql-151-to-sql-183-updates.md#sql-174-clslegalschedule) | Update an existing legal schedule | Stored Proc | `pk80001_legalnet.updateSchedule` | `clsLegalSchedule` | | [SQL-154](sql-151-to-sql-183-updates.md#sql-154-clsattorneyconflictcriteriaupdatesql) | Update an existing attorney conflict record | Inline | [ATTORNEY_CONFLICT](../database-tables.md#attorney_conflict) | `clsAttorneyConflict` | ## Delete operations Documented in full on [SQL-184 to SQL-205](sql-184-to-sql-205-deletes.md) (22 statements). Representative entries: | SQL ID | Description | Type | Tables | Business object | | --- | --- | --- | --- | --- | | [SQL-195](sql-184-to-sql-205-deletes.md#sql-195-clslegalcase) | Delete a legal case | Stored Proc | `pk80001_legalnet.DeleteLegalCase` | `clsLegalCase` | | [SQL-185](sql-184-to-sql-205-deletes.md#sql-185-clsattorneyconflictcriteriadeletesql) | Delete an attorney conflict record | Inline | [ATTORNEY_CONFLICT](../database-tables.md#attorney_conflict) | `clsAttorneyConflict` | | [SQL-200](sql-184-to-sql-205-deletes.md#sql-200-clslegalscheduledeleteschedule) | Delete a legal schedule | Stored Proc | `pk80001_legalnet.deleteSchedule` | `clsLegalSchedule` | ## Related documentation - [Index](../index.md) - [Overview](../overview.md) - [Architecture](../architecture.md) - [Dependencies](../dependencies.md) - [Configuration](../configuration.md) - [Operations and processes](../operations-processes.md) - [Business rules](../business-rules.md) - [Database tables](../database-tables.md) - [Procedures](../procedures/index.md) - [API reference](../api/index.md) ## Sources - `SAIF.Business.Claim.Legal\LegalNet\*`, `SAIF.Business.Claim.Legal\TableMaint\*`, `SAIF.Business.Claim.Legal\Print\*` (see individual SQL detail pages for exact per-statement file/line citations)